Bivariate analysis
Table calculus
`dplyr`
`dbplyr`
`dtplyr`
`data.table`
`arrow`
M1 MIDS/MFA/LOGOS |
| Année 2025 |
Code
con <- DBI::dbConnect(
RPostgreSQL::PostgreSQL(),
user=Sys.getenv('USERNAME'),
password=rstudioapi::askForPassword(),
dbname="bd_2023-24",
host="localhost",
port=5436
)With DBI::...
Code
dbGetQuery(con,
"SELECT
count(*)
FROM
nycflights.flights ;"
)https://dbplyr.tidyverse.org/index.html
Code
res <- dbSendQuery(con,
"SELECT
origin,
count(*) AS n
FROM
nycflights.flights
GROUP BY
origin"
)
df <- dbFetch(res)
dbClearResult(res)
head(df)With dbplyr::...
Code
dbplyr::db_connection_describe(con)Code
pg_flights |>
count(by=origin)Code
pg_airlines |>
glimpse()Code
dbDisconnect(con)Enjoy!